单据

概述

定义

select w.name, tab.name, t.tablename,
count(case when columnname = 'Processing' then columnname  end) as "Processing",  
count(case when columnname = 'Processed' then  columnname  end) as "Processed",  
count(case when columnname = 'DocumentNo'   then columnname  end) as "DocumentNo",
count(case when columnname = 'C_DocType_ID' then columnname  end) as "C_DocType_ID",  
count(case when columnname = 'IsApproved'   then columnname  end) as "IsApproved",
count(case when columnname = 'DocStatus' then  columnname  end) as "DocStatus",  
count(case when columnname = 'DocAction' then columnname  end) as "DocAction",  
count(case when columnname = 'Posted' then  columnname  end) as "Posted",  
count(case when columnname = 'DateDoc'   then columnname  end) as "DateDoc"
from ad_column c
join ad_table t on c.ad_table_id= t.ad_table_id and t.isview='N'
join ad_tab tab on tab.ad_table_id = t.ad_table_id and tab.isactive='Y'
join ad_window w on w.ad_window_id=tab.ad_window_id and w.entitytype= 'D' AND w.isactive='Y'
where columnname IN ('Processing','Processed','DocumentNo','C_DocType_ID','IsApproved','DocStatus','DocAction','Posted','DateDoc')
group by w.name, ta.name, t.tablename, c.ad_table_id order by 11 desc,12 desc,10 desc,9 desc,8 desc,7 desc,6 desc,5 desc,4 desc, c.ad_table_id;

单据类型

单据号

单据与工作流